• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• VB.Net - Use Dataview { Data Type Component } To Filter Data In Very Easy Way. No Need To Write SQL

VB.Net - Use Dataview { Data Type Component } To Filter Data In Very Easy Way. No Need To Write SQL

VB.Net - Use Dataview { Data Type Component } To Filter Data In Very Easy Way. No Need To Write SQL Queries, One SQL Query Enough To Do All

API Declarations


.SqlClient



Rate VB.Net - Use Dataview { Data Type Component } To Filter Data In Very Easy Way. No Need To Write SQL

• 1
• 2
• 3
• 4
• 5

(2(2 Vote))

        DataGridView1.DataSource = ReturnDataTable()

    End Sub

    Public Function ReturnDataTable() As DataTable

        Dim SQLCon As New SqlClient.SqlConnection("Data Source=UDEESHA;Initial Catalog=Gehan;Integrated Security=True;Pooling=False")
        SQLCon.Open()
        Dim SQLCom As New SqlClient.SqlCommand("SELECT * FROM Students", SQLCon)

        Dim DSet As New DataSet()
        Dim DAdap As New SqlClient.SqlDataAdapter(SQLCom)

        DAdap.Fill(DSet)

        Return DSet.Tables(0)

    End Function

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

        Dim DView As New DataView(ReturnDataTable())

        With DView
            .AllowDelete = False
            .AllowEdit = False
            .AllowNew = False
            .RowFilter = "StudName LIKE '" & TextBox1.Text.ToString().Trim() & "%'"
            .RowStateFilter = DataViewRowState.OriginalRows
            .Sort = "ID"
        End With

        DataGridView1.DataSource = DView

    End Sub